Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RefersToTransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN_TO | IdentityUUID | char(32) | Transaction(TR_TRN) |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | Transaction(TR_TRN) |
TransactionAssociationTypeCode (FK)(PK) | A retailer assigned code denoting the kind of relationship between the two Transactions. | CD_TYP_TRN_ASCTN | Code4 | char(4) | TransactionAssociationType(CO_TRN_ASCTN) |
SequenceNumber (PK) | A number that indicates the presentation order of TransactionAssociation entity type instances. The use of this attribute is determined by the application logic used to create and use this association. It may be used to indicate chronological order OR it may be used to establish a precedence in how retail transaction associations are to be processed. | IC_ASCTN_LTM_RTL_SQN_NMB | LineNumber | smallint | |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
TransactionAssociationEntryMethodCode | A code to denote how the TransactionAssociation was entered at the Workstation. | CD_TRN_ASCTN_ENR_MTH | EntryMethodCode | varchar(20) | |
OriginalSourceTransactionAssociationFlag | A boolean indicator that if set to YES or TRUE means that this association instance is the first of multiple associations. Note that this applies primarily where SequenceNumber is used as a precedence determination value NOT a chronological value. This requires some additional discussion and clarification. | FL_ORGL_SRC_TRN_ASCTN | Flag | integer | |